﻿<?php
  @header("content-Type: text/html; charset=utf-8"); //语言强制
  
  $specialTitle = '牛散100强买了什么股';
  
	require_once('head.php');
?>

<link rel="stylesheet" href="/css/list.css" type="text/css"/>
<link rel="stylesheet" href="/css/common.css" type="text/css"/>

<div class="gblb">
  <div class="hang1">
    <img src="/images/listPrefix.gif">
    自然人股东列表(<a href="http://gudahu.com/topNaturePerson.php?appearDate=2013-03-31" target="_self">2013-03-31</a> | <a href="http://gudahu.com/topNaturePerson.php?appearDate=2012-12-31" target="_self">2012-12-31</a>)
  </div>

<div class="hang2"><ul>  
<?php
  $appearDate = $_GET['appearDate'];
  if (empty($appearDate)){
  	$appearDate = '2013-03-31';
  }
  
  // Connect to the database 
  $dbc = mysqli_connect('localhost', 'root', 'k00l@1D;', 'gudahu')
    or die('Error connecting to MySQL server.');
	mysqli_set_charset($dbc, 'utf8');
  // Retrieve the score data from MySQL
  $query = "select holder_name from top_holder where holder_type = '自然人股' and appear_date = '".$appearDate."' group by holder_name having count(holder_name) > 1 order by share_ratio desc limit 100;";
  $result = mysqli_query($dbc, $query)
    or die('Error querying database.');
  $seq = 0;  
  while ($row = mysqli_fetch_array($result)) { 
      echo '<li><a target="_blank" href="http://gudahu.com/hotKeyword.php?keyword='.$row['holder_name'].'">'.$row['holder_name'].'</a></li>';
      $seq ++;
      if ($seq % 5 == 0) {
         echo '</ul></div><div class="hang2"><ul>'; 
      }
  }					    
  mysqli_close($dbc);
?>
</ul></div>
   
</div>

<?php
	require_once('foot.php');
?>  